﻿using System;
using System.Collections.Generic;

using System.Text;

namespace Corsat.Library.DataManager
{
    enum StoredProcedure
    {
        sp_GetAllItemsByCategory,
        sp_GetAllItemsByCategoryAndParentItem,
        SP_InsertAccount,
        SP_GetRelatedItems,
        sp_GetCourseLevels,
        sp_GetAllAccountsCorsatNumbers,
        sp_RegisterAccountCourse,
        sp_SelectAccount,
        sp_GetAllCoursesWithDays,
        sp_ActivateAccount,
        sp_UnregisterAccountCourse,
        sp_GetAccountHistoryCourses,
        sp_GetCourseId,
        sp_RegisterAccountTelephone,
        sp_GetAccountIdBySSNandYear,
        sp_GetAccountIdBySSN,
        sp_UpdateAccount,
        sp_GetCourseAbsence,
        sp_UpdateCourseAbsence,
        sp_GetCourseAccounts,
        sp_GetAllAccountsWithCorsatId,
        sp_GetAccountResults,
        sp_GetTechnologyExamAttendeesCount,
        sp_ReserveTechnologyCourse,
        sp_GetAllAccountsNames,
        sp_UpdateAccountConferenceStatus,
        sp_GetAccountResultsByAccountId,
        sp_GetTechnologyResults,
        sp_GetConferenceData,
        sp_UpdateAccountCourseGrade,
        sp_CanAttendCourseId,
        sp_GetQuestionsByCourseId,
        sp_GetQuestionDataByQuestionId,
        sp_InsertCourseQuestion,
        sp_UpdateCourseQuestion,
        sp_DeleteQuestion,
        sp_UpdateAccountData,
        sp_GetRandomExamByCourseId,
        sp_GetQuestionsRightAnswers,
    }

    public enum Category
    {
        CourseNames = 1,
        Dioceses = 2,
        Churchs = 3,
        CourseLevels = 4,
        TelephoneTypes = 5,
        Grades = 6,
        Days = 6,
        TechnologyCourses=8,
        StudyType = 9,
        Profession= 10
    }

    public enum SearchOptions
    {
        Name = 1,
        SocialSecurityNumber = 2,
        CorsatId = 3
    }

    public enum TechnologyCourse
    {
        Introduction = 323,
        WindowsAndVideoStudio = 324,
        Photoshop = 325,
        Powerpoint = 326,
        AutoplayMenuDesigner = 327,
        Facebook = 328
    }


    public enum ConferenceStatus
    {
        NotBooked = 0,
        Booked = 1,
        CompeleteBooking = 2
    }
}
